XECUTE field reference

The table below shows the XECUTE fields that are available to be reported on in the Reporting tab in XECUTE Client and for use in Data Feed Out publish events that are configured in XECUTE Config. Subsets of the fields are also available within the expression builder in the XECUTE applications and if named differently they appear in parentheses ().

The XECUTE Client reporting tab allows reports to be exported locally in various file formats and also shared with other XECUTE users within XECUTE Client.

The XECUTE Config Data Feed Out allows data to be published to RPM EPF servers for use by other systems. The publish events are initiated from within XECUTE Client.

Dataset Definitions (DSDs) are configured in RPM Integration Management Studio (IMS). Columns applicable to Data Feed Out are:

Not all fields are available to all report types.

margin-left: 0; margin-right: auto;" cellspacing="0">
Field GroupField NameAvailable In (Data FeedOut / Report type)DSD data typeDSD field type

Description

Date\Reporting Period

Finish

(Period Finish)

Schedule Results/ Schedule Report

Storage Locations/ Closing Balance Report

Date KeyDate and Time fields for the scheduling period finish.

Start

(Period Start)

Schedule Results/ Schedule Report

Storage Locations/ Closing Balance Report

Date KeyDate and Time fields for the scheduling period start.
Period Id

Schedule Results/ Schedule Report

Storage Locations/ Closing Balance Report

TextKeyConcatenated YYYYMMDD Period Name.
Period Name

Schedule Results/ Schedule Report

Storage Locations/ Closing Balance Report

TextKeyThe name of the period.
Period Number

Schedule Results/ Schedule Report

Storage Locations/ Closing Balance Report

NumericKeyThe period number.
Date\TaskStartSchedule Results/ Schedule ReportDateKey/FieldDate and Time fields for the task start.
FinishSchedule Results/ Schedule ReportDate Key/FieldDate and Time fields for the task finish.
Field GroupField NameAvailable In (Data FeedOut / Report type)DSD data typeDSD field type

Description

HaulageCycle DistanceSchedule Results/ Schedule ReportNumericFieldThe source to destination and return haulage distance (the odometer distance) in site configured units.
Cycle TimeSchedule Results/ Schedule ReportNumericFieldReported in decimal minutes the spot time at loader + Load time + Travel time(full) + Spot time at dump + Dump time + Travel time (empty).
Dump TimeSchedule Results/ Schedule ReportNumericFieldUser-entered time to dump truck in minutes.
Electricity Consumed (kWh)Schedule Results/ Schedule ReportNumericFieldThe nett electrical energy consumed by the truck in its respective scheduling step.
Equivalent Flat Haulage DistanceSchedule Results/ Schedule ReportNumericFieldA truck’s speed typically alternates when the truck travels between flat roads and non-flat roads. Factors like rolling resistance and traction coefficient, and speed limits on roads of specific grades, control the truck’s speed. Equivalent Flat Haul (EFL) is a way of comparing different haul routes with each other and roughly estimating trucking requirements. For the given route, EFL determines the length of the route is the route was completely flat (how far the truck would have moved if the earth was flat). To report the EFH, for the given scheduling step, the software back-calculates the flat haulage distance that would result in the same travel time as the non-flat haulage distance. This process generates a curve that compares the total travel time (source to destination, travelling with a full load and returning with an empty load). The process then interpolates the EFH from the given scheduling step’s haul route.
Equivalent Flat Haul (Alt.)Schedule Results/ Schedule ReportNumericFieldThe alternate Equivalent Flat Haul (alternate EFH) uses a different method to calculate the EFH (described above). For the given scheduling step, the software calculates the EFH based on the horizontal distance associated with the optimal one-way haulage route from the source to the destination (with a full load). The software applies adjustments to the calculation to account for uphill and downhill components of the one-way haul route.
Forward DistanceSchedule Results /Schedule ReportNumericFieldThe one-way haul distance of the forward haulage route, that is, source to destination odometer distance in site configured units.
Forward Haulage Maximum ElevationSchedule Results /Schedule ReportNumericFieldThe maximum z-coordinate value of the forward haul profile.
Forward Haulage Minimum ElevationSchedule Results /Schedule ReportNumericFieldThe minimum z-coordinate value of the forward haul profile.
Forward Haulage Negative Elevation ChangeSchedule Results /Schedule ReportNumericFieldThe sum of the negative elevation changes of the forward haul profile.
Forward Haulage Positive Elevation ChangeSchedule Results /Schedule ReportNumericFieldThe sum of the positive elevation changes of the forward haul profile.
Forward Haulage Travel TimeSchedule Results /Schedule ReportNumericFieldThe haulage travel time in the forward direction (hauling a load). This value, alongside the Reverse Haulage Travel Time value, adds up to the Travel Time value.
Fuel ConsumedSchedule Results /Schedule ReportNumericFieldThe fuel consumed for the principal truck over the scheduling step. Fuel consumption accounts for fuel used during load time, the travel time, and the dump time.
Maximum Tyre Workload (TKPH)Schedule Results /Schedule ReportNumericFieldTyre Kilometre per Hour (TKPH), a measure of tyre workload generated over the forward (loaded) and reverse (unloaded) distance for the scheduling step. TKPH includes the dump and load times which will have the effect of reducing tyre workloads (that is, tyre cools while stationary).
Load TimeSchedule Results/ Schedule ReportNumericFieldUser-entered time to load truck in minutes.
Number of TrucksSchedule Results/ Schedule ReportNumericFieldTruck Hours / (Hours per Truck per Period).
Reverse DistanceSchedule Results/ Schedule ReportNumericFieldThe one-way haul distance for the empty truck. Destination to source odometer distance.
Reverse Haulage Maximum ElevationSchedule Results /Schedule ReportNumericFieldThe maximum z-coordinate value of the reverse haul profile.
Reverse Haulage Minimum ElevationSchedule Results /Schedule ReportNumericFieldThe minimum z-coordinate value of the reverse haul profile.
Reverse Haulage Negative Elevation ChangeSchedule Results /Schedule ReportNumericFieldThe sum of the negative elevation changes of the reverse haul profile.
Reverse Haulage Positive Elevation ChangeSchedule Results /Schedule ReportNumericFieldThe sum of the positive elevation changes of the reverse haul profile.
Reverse Haulage Travel TimeSchedule Results /Schedule ReportNumericFieldThe haulage travel time in the reverse direction (with an empty load). This value, alongside the Forward Haulage Travel Time value, adds up to the Travel Time value.
Spot Time at DumpSchedule Results/ Schedule ReportNumericFieldUser entered time to spot at dump in minutes.
Spot Time at LoaderSchedule Results/ Schedule ReportNumericFieldUser-entered time to spot at loader in minutes.
Travel TimeSchedule Results/ Schedule ReportNumericFieldTravel time in minutes using the quickest path method. The time is calculated as per HAULSIM and adjusted by the expression set in XECUTE Config > Haulage.
Truck CapacitySchedule Results/ Schedule ReportNumericFieldMass / (Truck Payload / (Cycle Time / 60)).
Field GroupField NameAvailable In (Data FeedOut / Report type)DSD data typeDSD field type

Description

Material FlowActivitySchedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Design Request/

Text KeyThe activity definition name.
Activity AreaSchedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Design Request/

Text KeyThe activity area name.
Destination NameSchedule Results/ Schedule ReportText KeyMaterial flow destination node name.
Destination TypeSchedule Results/ Schedule ReportText KeyMaterial flow node type.
Dump BlockSchedule Results/ Schedule ReportText KeyThe dump block name.
Dump LiftSchedule Results/ Schedule ReportText KeyThe dump lift name.
Is Resource AssignedSchedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Design Request/

Text KeyThe activity area name.
Material Schedule Results
Publish Activity Areas
Text KeyMaterial types of the moved material.
Material MovementSchedule Results/ Schedule Report
Publish Activity Area
Text KeyTrue if material moves from source to destination.
Mining Level NameSchedule Results
Publish Activity Areas

Design Request/

Text KeyMining level name if material is mined from activity area.
Pit NameSchedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Design Request/

Text KeyName of the pit for the source record (activity area).
Resource NameSchedule Results/ Schedule ReportText KeyName of resource instance associated with the record's activity type.
Resource TypeSchedule Results/ Schedule ReportText KeyName of resource type associated with the record's activity type.
SliceSchedule Results/ Schedule Report

Activity Areas/ Activity Area Report

NumericKeyThe activity area slice number (each slice is treated as a reserved record).
SourceSchedule Results/ Schedule ReportText KeyThe material flow source node name.
Source TypeSchedule Results/ Schedule ReportText KeyThe material flow source mode type.
Material Flow\ Staged StockpileDestination BuildSchedule Results/ Schedule ReportText KeyThe build name of the material flow destination.
Destination ParcelSchedule Results/ Schedule ReportText KeyThe parcel name of the material flow destination.
Destination PileSchedule Results/ Schedule ReportText KeyThe pile name of the material flow destination.
Source BuildSchedule Results/ Schedule ReportText KeyThe build name of the material flow source.
Source ParcelSchedule Results/ Schedule ReportText KeyThe parcel name of the material flow source.
Source PileSchedule Results/ Schedule ReportText KeyThe pile name of the material flow source.
Field GroupField NameAvailable In (Data FeedOut / Report type)DSD data typeDSD field type

Description

Location\Staged StockpileBuild

Schedule Results/ Schedule Report

Storage Locations/ Closing Balance Report

Text KeyThe build name of the current location (staged stockpile node).
Pile

Schedule Results/ Schedule Report

Storage Locations/ Closing Balance Report

Text KeyThe pile name of the current location (staged stockpile node).
Pile State

Schedule Results/ Schedule Report

Storage Locations/ Closing Balance Report

Text KeyThe building and depleting phase of the pile for a period.
LocationDump BlockStorage Locations/ Closing Balance ReportText KeyThe dump block name of the current location.
Dump LiftStorage Locations/ Closing Balance ReportText KeyThe dump lift name of the current location.
LocationStorage Locations/ Closing Balance ReportText KeyThe current location name.
Location TypeStorage Locations/ Closing Balance ReportText KeyThe location node type.
MaterialStorage Locations/ Closing Balance ReportText KeyThe material name.
Field GroupField NameAvailable In (Data FeedOut / Report type)DSD data typeDSD field type

Description

Spatial Data (Data Feed Out only)Activity Area
Floor Polygon
Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Design Request/

Text Field

Activity Area floor polygon in WKT format

POLYGON Z ((x1 y1 z1,x2 y2 z2,...xn yn zn)).

Activity Area Floor Polygon - as designed

Schedule Results/ Schedule Report

Publish Activity Areas

Design Request/

TextFieldActivity Area floor (silhouette) polygon in WKT format.
Activity Area
Floor Surface
Schedule Results/ Schedule Report
Publish Activity Areas

Design Request/

Text Field

Activity Area floor surface in WKT format (TIN)

TIN (((x1 y1 z1,x2 y2 z2,x3 y3 z3,x1 y1 z1)),...).

Activity Area
Floor Surface - with radius

Schedule Results/ Schedule Report

Publish Activity Areas

Design Request/

Text FieldActivity Area floor surface with a specified buffer (radius) applied, in WKT format (TIN).
Activity Area
Roof Polygon
Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Design Request/

Text FieldActivity Area roof polygon in WKT format.
Activity Area
Roof Surface
Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Design Request/

Text FieldActivity Area roof surface in WKT format (TIN).
Activity Area
Solid
Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Design Request/

Text FieldActivity Area solid in WKT format (TIN).
Period Floor
Polygon
Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Design Request/

Text FieldPeriod portion of area floor polygon in WKT format.
Period Floor
Surface
Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Design Request/

Text FieldPeriod portion of area floor surface in WKT format (TIN).
Period Roof
Polygon
Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Design Request/

Text FieldPeriod portion of area roof polygon in WKT format.
Period Roof
Surface
Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Design Request/

Text FieldPeriod portion of area roof surface in WKT format (TIN).
Field GroupField NameAvailable In (Data FeedOut / Report type)DSD data typeDSD field type

Description

Principal FieldsAvg Flr Elevation

Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Storage Locations/ Closing Balance Report

Design Request/

NumericFieldThe average elevation (of each point) of the floor of the activity area.
Avg Tk

Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Storage Locations/ Closing Balance Report

Design Request/

NumericFieldThe average thickness of the activity area (Volume / Plan Area).
Density

Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Storage Locations/ Closing Balance Report

Design Request/

NumericFieldThe density of the activity area.
Grade Control Intersection Percent

Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Storage Locations/ Closing Balance Report

Design Request/

NumericFieldThe percentage of the activity area solid that intersects with grade control blocks (if imported).
Mass

Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Storage Locations/ Closing Balance Report

Design Request/

NumericFieldThe mass of the activity area (Volume * Density).
Plan Area

Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Storage Locations/ Closing Balance Report

Design Request/

NumericFieldThe surface area of the activity area.
Volume

Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Storage Locations/ Closing Balance Report

Design Request/

NumericFieldThe volume of the activity area.
Volume_Swollen

Schedule Results/ Schedule Report

Activity Areas/ Activity Area Report

Storage Locations/ Closing Balance Report

Design Request/

NumericFieldThe volume of the activity area with the swell factor applied.
Field GroupField NameAvailable In (Data FeedOut / Report type)DSD data typeDSD field type

Description

ProductivityActivity QuantitySchedule Results/ Schedule ReportNumericFieldThe aggregated quantity of the activity quantity field.
Activity Quantity UnitSchedule Results/ Schedule ReportText KeyThe units of the activity quantity field.
Available TimeSchedule Results/ Schedule ReportNumericFieldAvailable roster time for the reported period.
Delay DetailsSchedule Results/ Schedule ReportTextKeyThe maintenance order number.
DurationSchedule Results/ Schedule ReportNumericFieldResource productive time.
Is AvailableSchedule Results/ Schedule ReportTextKeyFlag to indicate whether the resource is in maintenance.
Is OperatingSchedule Results/ Schedule ReportText KeyFlag to indicate whether the resource is operating (productive activity or travelling).
Is ProductiveSchedule Results/ Schedule ReportText KeyFlag to indicate whether the resource is productive (productive activity).
Non Production TimeSchedule Results/ Schedule ReportNumeric FieldSum of work category periods excluding 'Available' roster time for a Resource for a reporting period.
Operating TimeSchedule Results/ Schedule ReportNumericFieldSum of 'Available' Roster time for a Resource for a reporting period.
Period Rate FactorSchedule Results/ Schedule ReportNumericFieldPeriod override factor rate.
Production Rate (Actual)Schedule Results/ Schedule ReportNumericFieldActivity quantity / Operating time.
Production Rate (Nominal)Schedule Results/ Schedule ReportNumericFieldProduction rate of the resource or process node.
Production Rate FactorSchedule Results/ Schedule ReportNumeric FieldProduction rate % (1=100%) that may be reduced due to the option to achieve blend.
Production Rate UnitSchedule Results/ Schedule ReportText KeyThe activity area resource productive rate unit.
Productive Activity QuantitySchedule Results/ Schedule ReportNumericFieldThe aggregated quantity for productive tasks.
Productive Activity Quantity UnitSchedule Results/ Schedule ReportTextKeyThe unit of the activity quantity field for productive tasks.
Productive TimeSchedule Results/ Schedule ReportNumericFieldSum of productive time for a resource.
Field GroupField NameAvailable In (Data FeedOut / Report type)DSD data typeDSD field type

Description

Wash FieldProductMass

Schedule Results/ Schedule Report

Storage Locations/ Closing Balance Report

NumericFieldThe mass (t) of the washed coal product.
Wash Plant Cut-Point

Schedule Results/ Schedule Report

Storage Locations/ Closing Balance Report

NumericFieldThe specific gravity at which the coal feed sinks within the washing unit.
Wash Plant Yield

Schedule Results/ Schedule Report

Storage Locations/ Closing Balance Report

Numeric

Field

The yield of the wash plant at the specified ash content.
Product<quality>

Schedule Results/ Schedule Report

Storage Locations/ Closing Balance Report

NumericFieldThe wash coal product quality value.